object fdeposayim: Tfdeposayim
  Left = 258
  Top = 154
  Width = 945
  Height = 580
  Caption = 'Stok Raporu'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  KeyPreview = True
  Menu = MainMenu1
  OldCreateOrder = False
  Position = poDefaultPosOnly
  OnClose = FormClose
  OnCreate = FormCreate
  OnKeyDown = FormKeyDown
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object Panel1: TPanel
    Left = 0
    Top = 501
    Width = 937
    Height = 33
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 2
    Visible = False
    DesignSize = (
      937
      33)
    object bkapat: TBitBtn
      Left = 877
      Top = 4
      Width = 57
      Height = 25
      Anchors = [akTop, akRight]
      Caption = 'Kapat'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 5
      OnClick = bkapatClick
    end
    object bexport: TBitBtn
      Left = 755
      Top = 4
      Width = 57
      Height = 25
      Anchors = [akRight]
      Caption = 'Export'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 4
      OnClick = bexportClick
    end
    object bambartoplamlari: TButton
      Left = 95
      Top = 4
      Width = 68
      Height = 25
      Caption = #304'rsaliye Yaz.'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 0
      TabStop = False
      Visible = False
      OnClick = bambartoplamlariClick
    end
    object bmalzemehareketleri: TButton
      Left = 171
      Top = 4
      Width = 73
      Height = 25
      Caption = 'Malzeme Har.'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 1
      TabStop = False
      Visible = False
      OnClick = bmalzemehareketleriClick
    end
    object bsiparishareketleri: TButton
      Left = 248
      Top = 4
      Width = 68
      Height = 25
      Caption = 'Sipari'#351' Har.'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 2
      TabStop = False
      Visible = False
      OnClick = bsiparishareketleriClick
    end
    object bstokexstre: TBitBtn
      Left = 319
      Top = 4
      Width = 67
      Height = 25
      Caption = 'Stok Ekstre'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clRed
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 3
      Visible = False
      OnClick = bstokexstreClick
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 0
    Width = 937
    Height = 131
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 0
    DesignSize = (
      937
      131)
    object Label1: TLabel
      Left = 5
      Top = 13
      Width = 32
      Height = 14
      Caption = 'Ambar'
      Transparent = True
    end
    object Label2: TLabel
      Left = 5
      Top = 34
      Width = 74
      Height = 14
      Caption = 'Ba'#351' .Stok Kodu'
      Transparent = True
    end
    object Label3: TLabel
      Left = 5
      Top = 56
      Width = 67
      Height = 14
      Caption = 'Bit .Stok Kodu'
      Transparent = True
    end
    object Label20: TLabel
      Left = 317
      Top = 11
      Width = 43
      Height = 14
      Caption = #220'st Grup'
      Transparent = True
    end
    object Label21: TLabel
      Left = 317
      Top = 35
      Width = 24
      Height = 14
      Caption = 'Grup'
      Transparent = True
    end
    object Label4: TLabel
      Left = 5
      Top = 79
      Width = 62
      Height = 14
      Caption = 'Stok Kodu %'
      Transparent = True
    end
    object Label22: TLabel
      Left = 317
      Top = 58
      Width = 29
      Height = 14
      Caption = 'Marka'
      Transparent = True
    end
    object Label5: TLabel
      Left = 317
      Top = 81
      Width = 28
      Height = 14
      Caption = 'Model'
      Transparent = True
    end
    object Bevel1: TBevel
      Left = 1
      Top = 101
      Width = 935
      Height = 5
      Anchors = [akLeft, akTop, akRight]
    end
    object Label6: TLabel
      Left = 373
      Top = 111
      Width = 66
      Height = 14
      Caption = 'Bakiye Durum'
    end
    object basStokkoduk: TEdit
      Left = 80
      Top = 31
      Width = 169
      Height = 22
      CharCase = ecUpperCase
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 1
    end
    object bitStokkoduk: TEdit
      Left = 80
      Top = 54
      Width = 169
      Height = 22
      CharCase = ecUpperCase
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 2
    end
    object sifrilariGostermek: TCheckBox
      Left = 64
      Top = 110
      Width = 104
      Height = 17
      TabStop = False
      Caption = 'S'#305'f'#305'rlar'#305' G'#246'sterme'
      Checked = True
      State = cbChecked
      TabOrder = 4
    end
    object sadecefarklarc: TCheckBox
      Left = 219
      Top = 110
      Width = 97
      Height = 17
      TabStop = False
      Caption = 'Farklar'#305' G'#246'ster'
      TabOrder = 6
    end
    object ChkTumu: TCheckBox
      Left = 251
      Top = 11
      Width = 49
      Height = 17
      Caption = 'T'#252'm'#252
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 5
      OnClick = ChkTumuClick
    end
    object ambark: TwwDBLookupCombo
      Left = 80
      Top = 8
      Width = 169
      Height = 22
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'DepoAdi'#9'20'#9'Depo Ad'#305#9'F'#9)
      LookupTable = dm.AmbarQ
      LookupField = 'id'
      Color = clWhite
      Navigator = False
      TabOrder = 0
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
      OnCloseUp = ambarkCloseUp
    end
    object cbUstGrup: TwwDBLookupCombo
      Left = 375
      Top = 8
      Width = 169
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'isim'#9'50'#9'isim'#9#9)
      LookupTable = dm.aqUstGrup
      LookupField = 'id'
      Style = csDropDownList
      Color = clWhite
      Navigator = False
      ParentFont = False
      TabOrder = 7
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
    end
    object cbGrup: TwwDBLookupCombo
      Left = 375
      Top = 31
      Width = 169
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'isim'#9'50'#9'isim'#9'F'#9)
      LookupTable = dm.aqGrup
      LookupField = 'id'
      Style = csDropDownList
      Color = clWhite
      Navigator = False
      ParentFont = False
      TabOrder = 8
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
    end
    object Stokkodu: TEdit
      Left = 80
      Top = 77
      Width = 169
      Height = 22
      CharCase = ecUpperCase
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 3
    end
    object cbMarka: TwwDBLookupCombo
      Left = 375
      Top = 54
      Width = 169
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'isim'#9'50'#9'isim'#9'F'#9)
      LookupTable = dm.aqMarka
      LookupField = 'id'
      Style = csDropDownList
      Color = clWhite
      Navigator = False
      ParentFont = False
      TabOrder = 9
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
    end
    object cbSon6Ay: TCheckBox
      Left = 1194
      Top = 32
      Width = 137
      Height = 17
      Caption = 'Son Ay Kullan'#305'lan Adet'
      TabOrder = 13
      Visible = False
    end
    object edSonAy: TwwDBSpinEdit
      Left = 1330
      Top = 28
      Width = 62
      Height = 22
      Increment = 1.000000000000000000
      MaxValue = 10000.000000000000000000
      Value = 6.000000000000000000
      TabOrder = 14
      UnboundDataType = wwDefault
      Visible = False
    end
    object cbGrupFarkli: TwwCheckBox
      Left = 545
      Top = 34
      Width = 46
      Height = 17
      TabStop = False
      DisableThemes = False
      AlwaysTransparent = False
      ValueChecked = 'True'
      ValueUnchecked = 'False'
      DisplayValueChecked = 'True'
      DisplayValueUnchecked = 'False'
      NullAndBlankState = cbUnchecked
      Caption = 'Farkl'#305
      TabOrder = 11
    end
    object cbModel: TwwDBLookupCombo
      Left = 375
      Top = 77
      Width = 169
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'isim'#9'50'#9'isim'#9'F'#9)
      LookupTable = dm.aqModel
      LookupField = 'id'
      Style = csDropDownList
      Color = clWhite
      Navigator = False
      ParentFont = False
      TabOrder = 10
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
    end
    object blistele: TBitBtn
      Left = 610
      Top = 24
      Width = 97
      Height = 48
      Caption = 'Listele - F5'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      TabOrder = 12
      OnClick = blisteleClick
    end
    object cbBakiye: TwwDBComboBox
      Left = 444
      Top = 108
      Width = 100
      Height = 22
      TabStop = False
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = False
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'KSYS G'#246'ster'#9'1'
        'Unity G'#246'ster'#9'2'
        'T'#252'm'#252'n'#252' G'#246'ster'#9'3')
      ItemIndex = 0
      Sorted = False
      TabOrder = 15
      UnboundDataType = wwDefault
    end
  end
  object PageControl1: TPageControl
    Left = 0
    Top = 131
    Width = 937
    Height = 370
    ActivePage = TS1
    Align = alClient
    TabOrder = 1
    object TS1: TTabSheet
      Caption = 'Liste'
      object cxGrid1: TcxGrid
        Left = 0
        Top = 0
        Width = 929
        Height = 341
        Align = alClient
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        PopupMenu = PopupMenu1
        TabOrder = 0
        LookAndFeel.Kind = lfUltraFlat
        LookAndFeel.NativeStyle = True
        object cxGrid1DBTableView1: TcxGridDBTableView
          NavigatorButtons.ConfirmDelete = False
          OnCustomDrawCell = cxGrid1DBTableView1CustomDrawCell
          DataController.DataSource = DepoSayimS
          DataController.Options = [dcoAnsiSort, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding]
          DataController.Summary.DefaultGroupSummaryItems = <
            item
              Kind = skSum
              Column = cxGrid1DBTableView1bakiye
              DisplayText = 'Bakiye Toplam'
            end>
          DataController.Summary.FooterSummaryItems = <
            item
              Kind = skSum
              FieldName = 'bakiye'
              Column = cxGrid1DBTableView1bakiye
            end
            item
              Kind = skSum
              FieldName = 'unitymiktar'
              Column = cxGrid1DBTableView1unitymiktar
            end
            item
              Kind = skSum
              FieldName = 'OperatorMiktar'
              Column = cxGrid1DBTableView1Operator
            end
            item
              Kind = skSum
              FieldName = 'GercekMiktar'
              Column = cxGrid1DBTableView1GercekMiktar
            end>
          DataController.Summary.SummaryGroups = <>
          FilterRow.InfoText = '  '
          FilterRow.Visible = True
          FilterRow.ApplyChanges = fracImmediately
          OptionsBehavior.IncSearch = True
          OptionsData.CancelOnExit = False
          OptionsData.Deleting = False
          OptionsData.DeletingConfirmation = False
          OptionsData.Editing = False
          OptionsData.Inserting = False
          OptionsSelection.UnselectFocusedRecordOnExit = False
          OptionsView.Footer = True
          OptionsView.Indicator = True
          Styles.StyleSheet = dm.tvssDevExpress
          object cxGrid1DBTableView1stokkodu: TcxGridDBColumn
            Caption = 'Stok Kodu'
            DataBinding.FieldName = 'stokkodu'
            Width = 138
          end
          object cxGrid1DBTableView1cinsi: TcxGridDBColumn
            Caption = 'Cinsi'
            DataBinding.FieldName = 'cinsi'
            Width = 198
          end
          object cxGrid1DBTableView1bakiye: TcxGridDBColumn
            Caption = 'Ger'#231'ek Stok'
            DataBinding.FieldName = 'bakiye'
            Width = 70
          end
          object cxGrid1DBTableView1Operator: TcxGridDBColumn
            Caption = 'Konsinye Stok'
            DataBinding.FieldName = 'OperatorMiktar'
            Width = 81
          end
          object cxGrid1DBTableView1GercekMiktar: TcxGridDBColumn
            Caption = 'Fiili Stok'
            DataBinding.FieldName = 'GercekMiktar'
          end
          object cxGrid1DBTableView1unitymiktar: TcxGridDBColumn
            Caption = 'Unity Stok'
            DataBinding.FieldName = 'unitymiktar'
            Width = 76
          end
          object cxGrid1DBTableView1Anastokkodu: TcxGridDBColumn
            DataBinding.FieldName = 'AnaStokkodu'
            Width = 93
          end
          object cxGrid1DBTableView1isletimsistemi: TcxGridDBColumn
            Caption = #304#351'letim Sistemi'
            DataBinding.FieldName = 'isletimsistemi'
            Width = 75
          end
          object cxGrid1DBTableView1GirisFatura: TcxGridDBColumn
            Caption = 'Giri'#351' Fatura'
            DataBinding.FieldName = 'GirisFatura'
            Visible = False
            Width = 69
          end
          object cxGrid1DBTableView1GirisUretim: TcxGridDBColumn
            Caption = 'Giri'#351' '#220'retim'
            DataBinding.FieldName = 'GirisUretim'
            Visible = False
          end
          object cxGrid1DBTableView1GirisRMA: TcxGridDBColumn
            Caption = 'Giri'#351' RMA'
            DataBinding.FieldName = 'GirisRMA'
            Visible = False
          end
          object cxGrid1DBTableView1CikisFatura: TcxGridDBColumn
            Caption = 'Fatura '#199#305'k'#305#351
            DataBinding.FieldName = 'CikisFatura'
            Visible = False
            Width = 68
          end
          object cxGrid1DBTableView1UretimSarf: TcxGridDBColumn
            Caption = #220'retim '#199#305'k'#305#351
            DataBinding.FieldName = 'UretimSarf'
            Visible = False
          end
          object cxGrid1DBTableView1CikisAmbar: TcxGridDBColumn
            Caption = 'Birebir '#199#305'k'#305#351' '
            DataBinding.FieldName = 'CikisAmbar'
            Visible = False
          end
          object cxGrid1DBTableView1MuadilSarf: TcxGridDBColumn
            Caption = 'Muadil '#199#305'k'#305#351
            DataBinding.FieldName = 'MuadilSarf'
            Visible = False
          end
          object cxGrid1DBTableView1CikisRma: TcxGridDBColumn
            Caption = #199#305'k'#305#351' RMA'
            DataBinding.FieldName = 'CikisRma'
            Visible = False
          end
          object cxGrid1DBTableView1CikisToplam: TcxGridDBColumn
            Caption = #199#305'k'#305#351' Toplam'
            DataBinding.FieldName = 'CikisToplam'
            Visible = False
          end
          object cxGrid1DBTableView1UreticiKodu: TcxGridDBColumn
            Caption = #220'retici Kodu'
            DataBinding.FieldName = 'UreticiKodu'
            Width = 92
          end
          object cxGrid1DBTableView1PazarlamaKodu: TcxGridDBColumn
            Caption = 'Pazarlama Kodu'
            DataBinding.FieldName = 'PazarlamaKodu'
            Width = 97
          end
          object cxGrid1DBTableView1GrupKodu: TcxGridDBColumn
            Caption = 'Grup Kodu'
            DataBinding.FieldName = 'GrupKodu'
            Visible = False
            Width = 91
          end
          object cxGrid1DBTableView1SayimGrubu: TcxGridDBColumn
            Caption = 'Say'#305'm Grubu'
            DataBinding.FieldName = 'SayimGrubu'
            Width = 85
          end
          object cxGrid1DBTableView1UstGrup: TcxGridDBColumn
            Caption = #220'st Grup'
            DataBinding.FieldName = 'UstGrup'
            Width = 99
          end
          object cxGrid1DBTableView1Grup: TcxGridDBColumn
            DataBinding.FieldName = 'Grup'
            Width = 95
          end
          object cxGrid1DBTableView1Marka: TcxGridDBColumn
            DataBinding.FieldName = 'Marka'
            Width = 94
          end
          object cxGrid1DBTableView1Model: TcxGridDBColumn
            DataBinding.FieldName = 'Model'
            Width = 110
          end
          object cxGrid1DBTableView1OzelKod1: TcxGridDBColumn
            Caption = #214'zelkod'
            DataBinding.FieldName = 'OzelKod1'
          end
          object cxGrid1DBTableView1AltGrup: TcxGridDBColumn
            DataBinding.FieldName = 'AltGrup'
            Visible = False
            Width = 100
          end
        end
        object cxGrid1Level1: TcxGridLevel
          GridView = cxGrid1DBTableView1
        end
      end
    end
    object TS2: TTabSheet
      Caption = 'Pivot'
      ImageIndex = 1
      object Panel3: TPanel
        Left = 0
        Top = 0
        Width = 929
        Height = 30
        Align = alTop
        BevelOuter = bvLowered
        TabOrder = 0
        object btListeGetir: TBitBtn
          Left = 9
          Top = 4
          Width = 105
          Height = 22
          Caption = 'Listeyi Getir'
          TabOrder = 0
          OnClick = btListeGetirClick
        end
      end
      object PivotGrid1: TcxDBPivotGrid
        Left = 0
        Top = 30
        Width = 929
        Height = 311
        Align = alClient
        Groups = <>
        TabOrder = 1
        object PivotGrid1UreticiKodu: TcxDBPivotGridField
          AreaIndex = 0
          IsCaptionAssigned = True
          Caption = #220'retici Kodu'
          DataBinding.FieldName = 'UreticiKodu'
          Visible = True
        end
        object PivotGrid1PazarlamaKodu: TcxDBPivotGridField
          AreaIndex = 1
          IsCaptionAssigned = True
          Caption = 'Pazarlama Kodu'
          DataBinding.FieldName = 'PazarlamaKodu'
          Visible = True
        end
        object PivotGrid1GrupKodu: TcxDBPivotGridField
          AreaIndex = 2
          IsCaptionAssigned = True
          Caption = 'Grup Kodu'
          DataBinding.FieldName = 'GrupKodu'
          Visible = True
        end
        object PivotGrid1SayimGrubu: TcxDBPivotGridField
          AreaIndex = 3
          IsCaptionAssigned = True
          Caption = 'Say'#305'm Grubu'
          DataBinding.FieldName = 'SayimGrubu'
          Visible = True
        end
        object PivotGrid1stokkodu: TcxDBPivotGridField
          Area = faRow
          AreaIndex = 2
          IsCaptionAssigned = True
          Caption = 'Stokkodu'
          DataBinding.FieldName = 'stokkodu'
          Visible = True
        end
        object PivotGrid1cinsi: TcxDBPivotGridField
          Area = faRow
          AreaIndex = 3
          IsCaptionAssigned = True
          Caption = 'Cinsi'
          DataBinding.FieldName = 'cinsi'
          Visible = True
        end
        object PivotGrid1bakiye: TcxDBPivotGridField
          Area = faData
          AreaIndex = 0
          IsCaptionAssigned = True
          Caption = 'Bakiye'
          DataBinding.FieldName = 'bakiye'
          Visible = True
        end
        object PivotGrid1UstGrup: TcxDBPivotGridField
          AreaIndex = 4
          IsCaptionAssigned = True
          Caption = #220'st Grup'
          DataBinding.FieldName = 'UstGrup'
          Visible = True
        end
        object PivotGrid1Grup: TcxDBPivotGridField
          Area = faRow
          AreaIndex = 0
          DataBinding.FieldName = 'Grup'
          Visible = True
        end
        object PivotGrid1Marka: TcxDBPivotGridField
          Area = faRow
          AreaIndex = 1
          DataBinding.FieldName = 'Marka'
          Visible = True
        end
        object PivotGrid1Model: TcxDBPivotGridField
          AreaIndex = 5
          DataBinding.FieldName = 'Model'
          Visible = True
        end
        object PivotGrid1AltGrup: TcxDBPivotGridField
          AreaIndex = 6
          IsCaptionAssigned = True
          Caption = 'Alt Grup'
          DataBinding.FieldName = 'AltGrup'
          Visible = True
        end
        object PivotGrid1unitymiktar: TcxDBPivotGridField
          AreaIndex = 7
          IsCaptionAssigned = True
          Caption = 'Unity Bakiye'
          DataBinding.FieldName = 'unitymiktar'
          Visible = True
        end
      end
    end
  end
  object ppDBPipeline3: TppDBPipeline
    DataSource = DepoSayimS
    AutoCreateFields = False
    UserName = 'DBPipeline3'
    Left = 16
    Top = 184
  end
  object ppReport1: TppReport
    AutoStop = False
    DataPipeline = ppDBPipeline3
    PassSetting = psTwoPass
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'Custom'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 6350
    PrinterSetup.mmMarginLeft = 6350
    PrinterSetup.mmMarginRight = 6350
    PrinterSetup.mmMarginTop = 6350
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 256
    Template.DatabaseSettings.DataPipeline = ppDBPipeline3
    Template.DatabaseSettings.Name = 'Rapor A'
    Template.DatabaseSettings.NameField = 'adi'
    Template.DatabaseSettings.TemplateField = 'ayar'
    Template.SaveTo = stDatabase
    Units = utMillimeters
    AllowPrintToFile = True
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OutlineSettings.CreateNode = True
    OutlineSettings.CreatePageNodes = True
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.WindowState = wsMaximized
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = False
    Left = 80
    Top = 184
    Version = '10.02'
    mmColumnWidth = 0
    DataPipelineName = 'ppDBPipeline3'
    object ppTitleBand2: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 10319
      mmPrintPosition = 0
      object ppcaption: TppLabel
        UserName = 'Label1'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Durum Raporu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 12
        Font.Style = [fsBold]
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 5292
        mmLeft = 21431
        mmTop = 4233
        mmWidth = 145786
        BandType = 1
      end
    end
    object ppHeaderBand2: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 6615
      mmPrintPosition = 0
      object ppShape1: TppShape
        UserName = 'Shape1'
        mmHeight = 6350
        mmLeft = 2381
        mmTop = 0
        mmWidth = 190500
        BandType = 0
      end
      object ppLabel9: TppLabel
        UserName = 'Label2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stokkodu'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 22225
        mmTop = 1588
        mmWidth = 16140
        BandType = 0
      end
      object ppLabel10: TppLabel
        UserName = 'Label3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Cinsi'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 67204
        mmTop = 1588
        mmWidth = 8731
        BandType = 0
      end
      object ppLabel13: TppLabel
        UserName = 'Label6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Bakiye'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 124354
        mmTop = 1323
        mmWidth = 11642
        BandType = 0
      end
      object ppLabel1: TppLabel
        UserName = 'Label4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'S'#305'ra'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4191
        mmLeft = 11642
        mmTop = 1588
        mmWidth = 6604
        BandType = 0
      end
      object ppLabel2: TppLabel
        UserName = 'Label5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'U.Stok'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4191
        mmLeft = 140494
        mmTop = 1588
        mmWidth = 11134
        BandType = 0
      end
      object ppLabel3: TppLabel
        UserName = 'Label7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Op.Stok'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4191
        mmLeft = 154252
        mmTop = 1588
        mmWidth = 13504
        BandType = 0
      end
      object ppLabel4: TppLabel
        UserName = 'Label9'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'G.Stok'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4191
        mmLeft = 171450
        mmTop = 1588
        mmWidth = 11345
        BandType = 0
      end
    end
    object ppDetailBand2: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 4498
      mmPrintPosition = 0
      object ppLine2: TppLine
        UserName = 'Line2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 4498
        mmLeft = 2646
        mmTop = 0
        mmWidth = 19050
        BandType = 4
      end
      object ppDBText10: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'bakiye'
        DataPipeline = ppDBPipeline3
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 3175
        mmLeft = 124090
        mmTop = 529
        mmWidth = 11906
        BandType = 4
      end
      object ppDBText7: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'cinsi'
        DataPipeline = ppDBPipeline3
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 3175
        mmLeft = 66940
        mmTop = 529
        mmWidth = 55563
        BandType = 4
      end
      object ppDBText6: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'stokkodu'
        DataPipeline = ppDBPipeline3
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 3260
        mmLeft = 22490
        mmTop = 529
        mmWidth = 42863
        BandType = 4
      end
      object ppDBCalc1: TppDBCalc
        UserName = 'DBCalc1'
        OnGetText = ppDBCalc1GetText
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataPipeline = ppDBPipeline3
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DBCalcType = dcCount
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 3351
        mmLeft = 11642
        mmTop = 529
        mmWidth = 6879
        BandType = 4
      end
      object ppLine1: TppLine
        UserName = 'Line1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 265
        mmLeft = 2910
        mmTop = 4233
        mmWidth = 189971
        BandType = 4
      end
      object ppLine3: TppLine
        UserName = 'Line3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 4498
        mmLeft = 192617
        mmTop = 0
        mmWidth = 25400
        BandType = 4
      end
      object ppDBText1: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'unitymiktar'
        DataPipeline = ppDBPipeline3
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 3175
        mmLeft = 139700
        mmTop = 529
        mmWidth = 11906
        BandType = 4
      end
      object ppDBText2: TppDBText
        UserName = 'DBText5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'OperatorMiktar'
        DataPipeline = ppDBPipeline3
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 3175
        mmLeft = 155840
        mmTop = 529
        mmWidth = 11906
        BandType = 4
      end
      object ppDBText3: TppDBText
        UserName = 'DBText6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'GercekMiktar'
        DataPipeline = ppDBPipeline3
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 3175
        mmLeft = 170921
        mmTop = 529
        mmWidth = 11906
        BandType = 4
      end
    end
    object ppFooterBand2: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 5821
      mmPrintPosition = 0
      object ppLabel15: TppLabel
        UserName = 'Label15'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Durum Raporu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3175
        mmLeft = 21431
        mmTop = 1058
        mmWidth = 24077
        BandType = 8
      end
      object ppVariable1: TppVariable
        UserName = 'Variable1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        BlankWhenZero = False
        CalcOrder = 1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        mmHeight = 3175
        mmLeft = 146579
        mmTop = 1058
        mmWidth = 11642
        BandType = 8
      end
      object ppSystemVariable1: TppSystemVariable
        UserName = 'SystemVariable1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageCount
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4233
        mmLeft = 189442
        mmTop = 1058
        mmWidth = 5556
        BandType = 8
      end
      object ppLabel16: TppLabel
        UserName = 'Label8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = '/'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4233
        mmLeft = 187061
        mmTop = 1058
        mmWidth = 1058
        BandType = 8
      end
      object ppSystemVariable2: TppSystemVariable
        UserName = 'SystemVariable2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageNo
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4233
        mmLeft = 179652
        mmTop = 1058
        mmWidth = 6350
        BandType = 8
      end
      object ppSystemVariable3: TppSystemVariable
        UserName = 'SystemVariable3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 49213
        mmTop = 1058
        mmWidth = 13758
        BandType = 8
      end
      object ppSystemVariable4: TppSystemVariable
        UserName = 'SystemVariable4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtTime
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3175
        mmLeft = 64823
        mmTop = 1058
        mmWidth = 10583
        BandType = 8
      end
    end
    object raCodeModule1: TraCodeModule
      ProgramStream = {
        01060F5472614576656E7448616E646C65720B50726F6772616D4E616D650621
        5265706F727441667465724175746F5365617263684469616C6F674372656174
        650B50726F6772616D54797065070B747450726F63656475726506536F757263
        65063E70726F636564757265205265706F727441667465724175746F53656172
        63684469616C6F674372656174653B0D0A626567696E0D0A200D0A656E643B0D
        0A0D436F6D706F6E656E744E616D6506065265706F7274094576656E744E616D
        65061B41667465724175746F5365617263684469616C6F674372656174650745
        76656E744944020A0000}
    end
    object ppParameterList1: TppParameterList
    end
  end
  object DepoSayim: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 3000
    Parameters = <>
    SQL.Strings = (
      
        'SELECT s.UreticiKodu,s.UreticiSatisKodu PazarlamaKodu,s.GrupKodu' +
        ','
      
        's.SayimGrubu,st.stokkod,s.stokkodu,s.cinsi,isnull(sum(st.gstok),' +
        '0) as bakiye,  '
      
        'STU.isim UstGrup,STG.isim Grup,Stm.isim Marka,STD.isim Model,STA' +
        '.isim AltGrup, '
      's.unitystokkod,0 as unitymiktar '
      'into #yeni '
      'FROM stoktakip st   '
      'join Stok s on (St.Stokkod=s.Stokkod)   '
      'Left join stUstGrupTanim STU on (STU.id=s.UstGrupId)   '
      'Left join stGrupTanim STG on (STG.id=s.GrupId)   '
      'Left join stMarkaTanim STM on (STM.id=s.MarkaId)   '
      'Left join stModelTanim STD on (STD.id=s.ModelId)   '
      'Left join stAltGrupTanim STA on (STA.id=s.AltGrupId)   '
      'Where   st.depokod=8  and s.GrupId=2'
      'group by s.UreticiKodu,s.UreticiSatisKodu ,s.GrupKodu,'
      's.SayimGrubu,st.stokkod,s.stokkodu,s.cinsi, '
      'STU.isim,STG.isim,Stm.isim,STD.isim,STA.isim,s.unitystokkod'
      ' select * from #yeni drop table #yeni')
    Left = 80
    Top = 240
  end
  object DepoSayimS: TDataSource
    DataSet = DepoSayim
    Left = 16
    Top = 240
  end
  object MainMenu1: TMainMenu
    Left = 144
    Top = 184
    object Listele1: TMenuItem
      Caption = 'Kay'#305't'
      GroupIndex = 1
      object Listele2: TMenuItem
        Caption = 'Listele'
        ShortCut = 116
        OnClick = blisteleClick
      end
      object Yazdr1: TMenuItem
        Caption = 'Yazd'#305'r'
        ShortCut = 123
        OnClick = bYazdirClick
      end
      object N1: TMenuItem
        Caption = '-'
      end
      object Kapat1: TMenuItem
        Caption = 'Kapat'
        ShortCut = 27
        OnClick = bkapatClick
      end
    end
  end
  object Unity_Stok: TADOQuery
    Connection = dm.Connect_Unity
    LockType = ltBatchOptimistic
    Parameters = <>
    Left = 144
    Top = 240
  end
  object PopupMenu1: TPopupMenu
    Left = 214
    Top = 187
    object AmbarToplamlar1: TMenuItem
      Caption = 'Ambar Toplamlar'#305
      OnClick = AmbarToplamlar1Click
    end
    object MalzemeHarektleri1: TMenuItem
      Caption = 'Malzeme Hareketleri'
      OnClick = bmalzemehareketleriClick
    end
    object SipariHareketleri1: TMenuItem
      Caption = 'Sipari'#351' Hareketleri'
      OnClick = bsiparishareketleriClick
    end
    object Yazdr2: TMenuItem
      Caption = 'Yazd'#305'r'
      OnClick = bYazdirClick
    end
  end
  object aq6Fatura: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'AY1'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end
      item
        Name = 'Cambar1'
        Attributes = [paSigned, paNullable]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end
      item
        Name = 'stokkod1'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) from Fatura,fathar where Fatura.bilis' +
        'no=fathar.bilisno and Fatura.Tarih between GetDate()-30*:AY1 and' +
        ' Getdate() and Fatura.faturatipi=8 and Fatura.Ambar=:Cambar1 and' +
        ' Fathar.stokkod =:stokkod1 and Fathar.islem='#39'-'#39'),0)'
      'As Miktar')
    Left = 214
    Top = 238
  end
  object aq6Ambar: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'AY3'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'Gambar3'
        Attributes = [paSigned, paNullable]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end
      item
        Name = 'Cambar3'
        Attributes = [paSigned, paNullable]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end
      item
        Name = 'stokkod3'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) from stokfisihar,Stokfisi where StokF' +
        'isi.id=StokFisihar.stokFisiid and Stokfisi.Tarih between GetDate' +
        '()-30*:AY3 and Getdate()  and StokFisi.Fistipi='#39'61'#39' and StokFisi' +
        '.Gambar=:Gambar3 and StokFisi.Cambar=:Cambar3 and StokFisi.onayl' +
        'a='#39'O'#39' and StokFisi.parcadegisimi='#39'1'#39' and StokFisihar.stokkod =:s' +
        'tokkod3 and StokFisihar.islem='#39'*'#39'),0)'
      'As Miktar')
    Left = 272
    Top = 238
  end
  object aq6MuadilSarf: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'AY4'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'Cambar4'
        Attributes = [paSigned, paNullable]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end
      item
        Name = 'stokkod4'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) Miktar from stokfisihar,Stokfisi wher' +
        'e StokFisi.id=StokFisihar.stokFisiid and Stokfisi.Tarih between ' +
        'GetDate()-30*:AY4 and Getdate()  and StokFisi.Fistipi='#39'21'#39' and S' +
        'tokFisi.parcadegisimi=1 and StokFisi.Cambar=:Cambar4 and StokFis' +
        'i.onayla='#39'O'#39' and StokFisihar.stokkod =:stokkod4 and StokFisihar.' +
        'islem='#39'-'#39'),0)'
      'As Miktar')
    Left = 211
    Top = 297
  end
  object aqUretimSarf: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'AY2'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'Cambar2'
        Attributes = [paSigned, paNullable]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end
      item
        Name = 'stokkod2'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) Miktar from stokfisihar,Stokfisi wher' +
        'e StokFisi.id=StokFisihar.stokFisiid and Stokfisi.Tarih between ' +
        'GetDate()-30*:AY2 and Getdate()  and StokFisi.Fistipi='#39'21'#39' and S' +
        'tokFisi.uretimEmriNo is not null and StokFisi.Cambar=:Cambar2 an' +
        'd StokFisi.onayla='#39'1'#39' and StokFisihar.stokkod =:stokkod2 and Sto' +
        'kFisihar.islem='#39'-'#39'),0)'
      'As Miktar')
    Left = 280
    Top = 296
  end
  object aq6FaturaAlis: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'stokkod1'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) from Fatura,fathar where Fatura.bilis' +
        'no=fathar.bilisno and Fatura.faturatipi=1  and Fatura.Ambar=4 an' +
        'd Fathar.stokkod =:stokkod1 and Fathar.islem='#39'+'#39'),0)'
      'As Miktar')
    Left = 376
    Top = 239
  end
  object aqUretimGiris: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'Gambar2'
        Attributes = [paSigned, paNullable]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end
      item
        Name = 'stokkod2'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) Miktar from stokfisihar,Stokfisi wher' +
        'e StokFisi.id=StokFisihar.stokFisiid and Stokfisi.Gambar=:Gambar' +
        '2 and StokFisi.Fistipi='#39'01'#39' and StokFisihar.stokkod =:stokkod2 a' +
        'nd StokFisihar.islem='#39'+'#39'),0)'
      'As Miktar')
    Left = 380
    Top = 293
  end
  object aqGirisRMA: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'stokkod'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) Miktar from stokfisihar,Stokfisi wher' +
        'e StokFisi.id=StokFisihar.stokFisiid and StokFisi.Fistipi='#39'02'#39' a' +
        'nd StokFisihar.stokkod =:stokkod),0)'
      'As Miktar')
    Left = 379
    Top = 352
  end
  object aqCikisRMA: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 3000
    Parameters = <
      item
        Name = 'AY'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = 0
      end
      item
        Name = 'stokkod'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'Select '
      
        'isnull((select Sum(Miktar) Miktar from stokfisihar,Stokfisi wher' +
        'e StokFisi.id=StokFisihar.stokFisiid and Stokfisi.Tarih between ' +
        'GetDate()-30*:AY and Getdate() and StokFisi.Fistipi='#39'22'#39' and Sto' +
        'kFisihar.stokkod =:stokkod),0)'
      'As Miktar')
    Left = 279
    Top = 353
  end
end
